Release 10.1A: OpenEdge Development:
Progress Dynamics Getting Started

Viewing an SDO

One of the SDOs that you use repeatedly in this tutorial is the Customer SDO.

To view the Customer SDO:

Choose the Open Object button on the AppBuilder toolbar.
Select the ds-OE module from the Module combo box. This filters out all Repository objects except those in the Order Entry module.
Select DynSDO (Dynamic SmartDataObject) from the Type combo box.
Select armcufullo in the browse. Note that the object filenames are made by combining the tables’ entity names with the suffixes specified in the Object Generator, as shown:



Note: If you type the first few letters of a filename in the Object Filename field, the browse filters on objects that begin with the letters you typed.
Double-click on its row in the browse or choose Open. A design window for the SDO appears:



Double-click inside the design window to look at the query the Object Generator created for you, as shown:



With the Query button, you can edit the query. For example, if there is a description field that you always want to have available when using the Customer table, such as the RepName field in the SalesRep table, you can edit the query to add a join to the table that contains it.

With the Fields button, you can edit the list of fields defined in the SDO’s temp-table. By default for generated SDOs, all fields are included in the list. Also by default, all fields, except the Progress Dynamics Object ID fields, are marked as updateable. To reduce the amount of data sent across the AppServer connection, you might remove fields that are never directly viewed or updated in the client part of your application.

The DLP field shows the location of the data logic procedure for the SDO. This file is where business logic like a validation hook procedure goes.

Note: Do not make any changes to the query at this time.
Choose Cancel and then close the SDO’s design window.